package com.scu.bank.model.dao;

import com.scu.bank.model.base.BaseDao;
import com.scu.bank.model.example.NoticeExample;
import com.scu.bank.model.pojo.Notice;
import org.apache.ibatis.annotations.ResultMap;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface NoticeDao extends BaseDao<Notice> {
    @Select("SELECT * FROM t_sys_notice WHERE is_del = 0 AND start_time <= NOW() AND (end_time >= NOW() OR end_time IS NULL) limit 0,10")
    @ResultMap("BaseResultMap")
    List<Notice> getNotice();
}